from app import db
from datetime import datetime

class IndustryScore(db.Model):
    __tablename__ = 'industry_scores'
    
    id = db.Column(db.Integer, primary_key=True)
    marine_area_id = db.Column(db.Integer, db.ForeignKey('marine_areas.id'))
    industry_type = db.Column(db.Enum('fishery', 'shipping', 'tourism', 'energy', 'aquaculture', 'biotechnology'))
    score = db.Column(db.DECIMAL(5, 2))
    evaluation_date = db.Column(db.Date, nullable=False)
    created_at = db.Column(db.DateTime, default=datetime.utcnow) 